﻿--创建ICP
CREATE PROCEDURE [dbo].[proc_SiteICP_Create]
	(
	@SId int,
    @CustomerId Nvarchar(50),
    @CustomerName Nvarchar(50),
    @XingZhi Nvarchar(50),
    @ZhengJian Nvarchar(50),
    @Faren Nvarchar(50),
    @ShengFen Nvarchar(50),
    @City Nvarchar(50),
    @Address Nvarchar(100),
    @FZR_Name Nvarchar(50),
    @FZR_Sex Nvarchar(50),
    @FZR_ZhengJian Nvarchar(50),
    @FZR_Tel Nvarchar(50),
    @FZR_Fax Nvarchar(50),
    @FZR_Mobile Nvarchar(50),
    @FZR_Email Nvarchar(50),
    @WebName Nvarchar(50),
    @WebAddress Nvarchar(50),
    @KongJian_Size Nvarchar(10),
    @KongJian_Year Nvarchar(10),
    @KongJian_End datetime,
    @ICP_num Nvarchar(20),
    @Sales Nvarchar(50),
    @UpTime datetime
	)
AS
begin
	Insert Into SiteICP
	(
	SId,
    CustomerId,
    CustomerName,
    XingZhi,
    ZhengJian,
    Faren,
    ShengFen,
    City,
    Address,
    FZR_Name,
    FZR_Sex,
    FZR_ZhengJian,
    FZR_Tel,
    FZR_Fax,
    FZR_Mobile,
    FZR_Email,
    WebName,
    WebAddress,
    KongJian_Size,
    KongJian_Year,
    KongJian_End,
    ICP_num,
    Sales,
    UpTime
	)
	Values
	(
	@SId,
    @CustomerId,
    @CustomerName,
    @XingZhi,
    @ZhengJian,
    @Faren,
    @ShengFen,
    @City,
    @Address,
    @FZR_Name,
    @FZR_Sex,
    @FZR_ZhengJian,
    @FZR_Tel,
    @FZR_Fax,
    @FZR_Mobile,
    @FZR_Email,
    @WebName,
    @WebAddress,
    @KongJian_Size,
    @KongJian_Year,
    @KongJian_End,
    @ICP_num,
    @Sales,
    @UpTime
	)
end
	RETURN
